Computer and Modernization ›› 2010, Vol. 1 ›› Issue (10): 186-188.doi: 10.3969/j.issn.1006-2475.2010.10.051

• 应用与开发 • Previous Articles     Next Articles

Complex String Validation Through Use of CLR in SQL Server 2005

CHANG Jie   

  1. Information Engineering Department, Lianyungang Branch of Finance and Economics, Jiangsu Union Technical Institute, Lianyungang 222003, China
  • Received:2010-06-17 Revised:1900-01-01 Online:2010-10-21 Published:2010-10-21

Abstract: Complex string validation in SQL Server 2005 is very difficult by check constraint. For SQL Server 2005 integrates CLR, so using the regular expression of C# is able to solve the problem. The paper describes the application of CLR in the SQL Server 2005 basically. The important step and code for SQL CLR to validate email is also given in detail.

Key words: CLR, SQL Server 2005, regular expression, trigger

CLC Number: